UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Aa8lL8x7cju7Zs9fwmRGRTcnwNJMkTYt3f3k3tgGdi4='
WHERE
key_id = '93f193b9f97c6f6bf592059e25029e9d116d6b6e9cd93407fe4fbd9ce789df5c'
AND (
token = 'Aa8lL8x7cju7Zs9fwmRGRTcnwNJMkTYt3f3k3tgGdi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)