UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WRrtIySna8FeeUtPDXM2LnT8V6hPI6i5HCJV2SmhatU='
WHERE
key_id = 'daa48172fa8ebac055adc969ca8c764fd13adde9632a27a47b6a4cde908d791a'
AND (
token = 'WRrtIySna8FeeUtPDXM2LnT8V6hPI6i5HCJV2SmhatU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)