UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SXzdR35awCpYrxrmO7KbwSFXbaEUNvEpFz418UxC5n8='
WHERE
key_id = '9f3f537944a04e4d8ac24b5e883545f520e043c80cf8b2f5b660a767e4a96fba'
AND (
token = 'SXzdR35awCpYrxrmO7KbwSFXbaEUNvEpFz418UxC5n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)