UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eErFXAaI0ZW3SZbduXJOt1Kn3V9ZbOxYK8y+mcysUE0='
WHERE
key_id = '7c04ce6306bf77aa43db3dc47626e1ee567e80ff02eca53453b952f7a6ca5dd2'
AND (
token = 'eErFXAaI0ZW3SZbduXJOt1Kn3V9ZbOxYK8y+mcysUE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)