UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B38k/+XALDb3IA/5+Cs2LDixy7g2gm0uuJGvU25OVIg='
WHERE
key_id = 'e9a889307051a6bd6140c5ed72cfd358838f8433bccf1bbb992ed1a3c42cb966'
AND (
token = 'B38k/+XALDb3IA/5+Cs2LDixy7g2gm0uuJGvU25OVIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)