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