UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zY0uLe6oTos+c5oAj48oXCd6ceG8hbuBaZNQGoCHZc='
WHERE
key_id = '0ccaeedb8cd29c979614f6c4ae16d4087ed414145b796912a66a32eb61cf2fc7'
AND (
token = '6zY0uLe6oTos+c5oAj48oXCd6ceG8hbuBaZNQGoCHZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)