UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjW8oshjQo0QHqxasEFAQtckciQYar9tfg4h+xoseow='
WHERE
key_id = '1a39c4ad9e0887307b1d29a7577d65bdaa4f99cb60d48cd1bc9ed4aa5834c45f'
AND (
token = 'hjW8oshjQo0QHqxasEFAQtckciQYar9tfg4h+xoseow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)