UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8E1hgawi4ndzw3rVUlqoYJvVO/D06VDNs+dB2MOWGo='
WHERE
key_id = 'd9c36b58011070b27c606ada377811d0f64b4c6d06547700e2bc9c3083fc046a'
AND (
token = 'W8E1hgawi4ndzw3rVUlqoYJvVO/D06VDNs+dB2MOWGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)