UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8XdEdImB77msZTIvg5kfOyo7l/hJDI91G1Gd6aiLUw='
WHERE
key_id = 'd297c3e4deccd7682a00163a6219ac8ebfab8c0775f732c8eede46cfd7e5cf80'
AND (
token = 'S8XdEdImB77msZTIvg5kfOyo7l/hJDI91G1Gd6aiLUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)