UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dc9ujVCx1KQWrHS0hK1OVqY8a4upEwyPWQnd4t4JX3M='
WHERE
key_id = 'ef83f25226784651a2a3057d74349b062cb2e311f94e3f70104948b59d6171d2'
AND (
token = 'dc9ujVCx1KQWrHS0hK1OVqY8a4upEwyPWQnd4t4JX3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)