UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snPHqU9g9lKe42i489NXB9jDsaaqaNIEjXe0eq+Hsoo='
WHERE
key_id = 'a236bf748929c5d60f5db4bb34e396cd2ead91f5dbe4df4a07e5882bf7a1cd4c'
AND (
token = 'snPHqU9g9lKe42i489NXB9jDsaaqaNIEjXe0eq+Hsoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)