UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9xzty/1d23gHoZ6GBRP+5waamPPRmVVZe/3CC/iHco='
WHERE
key_id = 'd9a2e1c0e60b154a8d41bfae7a5c86b9bb38788714c27c4910b1491262a9fcf1'
AND (
token = 'D9xzty/1d23gHoZ6GBRP+5waamPPRmVVZe/3CC/iHco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)