UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O4d0XaYOiN54dmZapqdmCRz5+nsBhiZCDduvSxAINxQ='
WHERE
key_id = '9dfb521f0cbd67fb3b6ca3e8be0bdfad2387ed64a20859989da943ab576bd97b'
AND (
token = 'O4d0XaYOiN54dmZapqdmCRz5+nsBhiZCDduvSxAINxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)