UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4NO1dwi+J8E+/OqRSIrc470Ucn69+wq1sEBiOVrYGw='
WHERE
key_id = 'a150d01b1343da3b5e73adc9195c1c18ee83951fc78cf8e54ed92a979bb775b6'
AND (
token = 'p4NO1dwi+J8E+/OqRSIrc470Ucn69+wq1sEBiOVrYGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)