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