UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIo99NiAI8OJcKq7YNdjoTaqYBIq8tW3ouqclbdjSiE='
WHERE
key_id = 'e894895312367e0958bec7536c010ae190b03528816d2d12d4e2efb818b2020f'
AND (
token = 'pIo99NiAI8OJcKq7YNdjoTaqYBIq8tW3ouqclbdjSiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)