UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WNA9mz3xb2+oB/QJQQKZ8if/oCBjqZNdxtWlFXEBzbM='
WHERE
key_id = '9dcca98970588c008a5b53914ffe0fc35f609c355079874d3bb1626aad370a0a'
AND (
token = 'WNA9mz3xb2+oB/QJQQKZ8if/oCBjqZNdxtWlFXEBzbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)