UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKsw4jqRHK4la1E/dEdHS8o3EayFPlADTOj6XLKOw3o='
WHERE
key_id = 'e37818f195827db9d6a23c033c72a571e117aa60588840cdc8157bf72189db1c'
AND (
token = 'yKsw4jqRHK4la1E/dEdHS8o3EayFPlADTOj6XLKOw3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)