UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UnVJYKiIcdRNCfQAmxIP7AGwbr/twNsUznA7THfIai8='
WHERE
key_id = 'bef9c690328064f2d4b873a5d0ce08af476f744f44b03aed1bd64d1053872793'
AND (
token = 'UnVJYKiIcdRNCfQAmxIP7AGwbr/twNsUznA7THfIai8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)