UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oJ1MQKBuuciklMYrC+B8U4WMiItYH3073r4Z7RvUNxA='
WHERE
key_id = '2ae8fcc852f60191fd2a998fbf8dc47ca27dac26fb242f9ec23a686ba2cae908'
AND (
token = 'oJ1MQKBuuciklMYrC+B8U4WMiItYH3073r4Z7RvUNxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)