UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4knJ0F6JYOiu1sK7jj+S9YZQrFS/PHwXEQkKfI5b+b0='
WHERE
key_id = '046378b3331912a6969a2217a95a229bfe2568405d636275697d47d3b86b0919'
AND (
token = '4knJ0F6JYOiu1sK7jj+S9YZQrFS/PHwXEQkKfI5b+b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)