UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIJUrZLbrQK4WjHHDLxa6P94A/3XvYCA5LcTLlGt5BE='
WHERE
key_id = '5253df763e6d79dc3aed8ae48a569ac1670233ad1aee487652bba56b496fab52'
AND (
token = 'sIJUrZLbrQK4WjHHDLxa6P94A/3XvYCA5LcTLlGt5BE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)