UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NMcwhUvS6icLZUvNCauFUTdh0jf3lZPDi92sU+sggas='
WHERE
key_id = '48cff1b67154a527579fe429fe8271ba76f75f27e8cd8e48d8d8ba38a0d851df'
AND (
token = 'NMcwhUvS6icLZUvNCauFUTdh0jf3lZPDi92sU+sggas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)