UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SP0zm78NPOsWoCYFHKhfzwQOgDMGpGXRVYJSb+72ZiA='
WHERE
key_id = 'd4dbb8137e8ebe2137371569d1691c97605f5602f6ef5f11cfb2f273af76749b'
AND (
token = 'SP0zm78NPOsWoCYFHKhfzwQOgDMGpGXRVYJSb+72ZiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)