UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wJ9iuGV3hjeVFTcfohVUKtMmR/6rGK5drCGWrFdI2BA='
WHERE
key_id = '9ccc6f33d5bb98c2037114556e6862a2a7fd613d3c1be1d123d461afd7c486bd'
AND (
token = 'wJ9iuGV3hjeVFTcfohVUKtMmR/6rGK5drCGWrFdI2BA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)