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