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