UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hcDFJ7w6/SRdOF8LUO9DWAyqVLHBAE7HZtsYLg6kjA='
WHERE
key_id = '7ed9102439684c08046d86fe86f1918d364e88dfb020172359d8d9c3723bd539'
AND (
token = '8hcDFJ7w6/SRdOF8LUO9DWAyqVLHBAE7HZtsYLg6kjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)