UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dgQtbFgNtKFVNuOZJSy4zq3iXo4K30zBIDRgixZ9rk='
WHERE
key_id = '3115e403c8ff89f13ecc23af4dc42b15964991e1c54b55993653cf2fa06e6c1c'
AND (
token = '8dgQtbFgNtKFVNuOZJSy4zq3iXo4K30zBIDRgixZ9rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)