UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ca8kHwSjFbMA+zhc8oU2DmN8nEKizWOBWB/w2W8yhz8='
WHERE
key_id = '575477a827d79a2209cdc6a6bb3178c3134c6566b50518bc73290ac04198bb6b'
AND (
token = 'Ca8kHwSjFbMA+zhc8oU2DmN8nEKizWOBWB/w2W8yhz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)