UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yKUM58F6OHyimNF1lt1WeLHRRlmZsIDebuM1YuwXgA='
WHERE
key_id = '4f3238b85aa4c7761ab2193e75bf27796bee4fdb2c4670374c587fba7e735b93'
AND (
token = '1yKUM58F6OHyimNF1lt1WeLHRRlmZsIDebuM1YuwXgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)