UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6fQjim484EwDIUW9Fwz1RKCvLEP415i6Thf8Viqpr7U='
WHERE
key_id = 'b5af037599e635f50aa35f79521949837c3853658b39cb12a8d5e88180caf39b'
AND (
token = '6fQjim484EwDIUW9Fwz1RKCvLEP415i6Thf8Viqpr7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)