UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'luIhKfyV94coaUfz1f2eEEhjvu7k1nhDjwssdHGe69U='
WHERE
key_id = 'e1005f9e8683bd80fc3f96a5a252af71d2032c937fe063e800e4ae7b9a8ee925'
AND (
token = 'luIhKfyV94coaUfz1f2eEEhjvu7k1nhDjwssdHGe69U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)