UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCaW002hOOlUhgSR0VCmYJeA7aVIMlf0D2JquApFQu8='
WHERE
key_id = '29fd651506d24c452c1ce085ad108472d6e830ff3a3d253051a7d01dcbe12b12'
AND (
token = 'SCaW002hOOlUhgSR0VCmYJeA7aVIMlf0D2JquApFQu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)