UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccRN4OnChlxJYWsozjJMkWLpdFh17OZWwqXMEg4GNgY='
WHERE
key_id = 'a30933955ba92428f0c109952c6c853c141b254e4240d712a189a7d3e734c11a'
AND (
token = 'ccRN4OnChlxJYWsozjJMkWLpdFh17OZWwqXMEg4GNgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)