UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7c+tq/GoLzIZjucVWmMikgkuXTzRncJSuO2+q1F/J0='
WHERE
key_id = 'b3013917e481390638e2a2505533ca900a18358c71b69e585ab01363bece58ba'
AND (
token = 'd7c+tq/GoLzIZjucVWmMikgkuXTzRncJSuO2+q1F/J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)