UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ4RNBOnJwo1ysLpHSIUXXLCcyas46M+dhIw/xELxeI='
WHERE
key_id = '27f1a1b9f145ad2dace7ba65457b66eb56f9cb582319a8541c0745dc90dc3264'
AND (
token = 'gJ4RNBOnJwo1ysLpHSIUXXLCcyas46M+dhIw/xELxeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)