UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7ZsudBKDPnjDPEm2sBQDTOb4dP3c7p2Vi4JEubF9xA='
WHERE
key_id = '50d59c18405e4946838fe539fd1a7bb7569d2cb02969f77baf49b966e0202efb'
AND (
token = 'C7ZsudBKDPnjDPEm2sBQDTOb4dP3c7p2Vi4JEubF9xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)