UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/+myRTNVkX6D3J/NfWAOeS9DLEuU9nX13TAxGf091kA='
WHERE
key_id = 'b6f2978ca208f1769d28dcb3214f164c5511749cad0a2f114bfe507b3127bec5'
AND (
token = '/+myRTNVkX6D3J/NfWAOeS9DLEuU9nX13TAxGf091kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)